{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Disclaimer","Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Disclaimer","index":0,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[9,3,10,8],[11,3,25,8],[21,10,25,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Disclaimer"]
[]
[null,null,null,"This Design Calculation Spreadsheet is provided \"as-is\" without warranty of any kind. The Montana Department of Transportation makes no representations or warranties whatsoever with respect to the accuracy or completeness of this tool and assumes no responsibility for the suitability of this tool for a particular purpose; and MDT will not be liable for any damages incurred as a result of errors in this tool. \n\nBy selecting Accept, you are agreeing to these terms and conditions."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"WARNING: \nFor the tool to work properly, please make sure you click on \"Enable Content/Macros\" if the security warning appears."]

{"sheet":"Sheet1","index":1,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":true,"merged":[[0,0,0,7],[22,3,22,4],[24,3,24,4],[2,1,2,6],[14,0,14,7],[20,3,20,4],[16,0,16,7],[18,3,18,4],[19,3,19,4],[20,5,20,7]]}
["Instructions for this sheet: Modify ONLY areas highlighted with a green background. All other areas will calculate."]
[]
[8541000,"Luther - E & W",null,null,null,null,null,"2021-08-03"]
[]
["Preliminary Construction Cost Estimate"]
[]
[null,null,"Estimated cost",null,"Inflation (INF)\n(from PPMS)",null,"TOTAL costs\nw/INF + IDC\n(from PPMS)"]
[]
[null,"TOTAL CN",{"$f":"ROUND(D21,-3)","v":10488000},null,{"$f":"ROUND(C9*$I$9,-3)","v":1938000},null,{"$f":"ROUND(((C9+C9*$I$9)*$I$13+C9+C9*$I$9),-3)","v":13627000},null,0.184817208449889,"Inflation Factor (from PPMS - copy over directly from PPMS for full decimal places available)"]
[]
[null,{"$f":"CONCATENATE(\"CE (\",I11*100,\"%)\")","v":"CE (12%)"},{"$f":"ROUND(C9*(I11),-3)","v":1259000},null,{"$f":"ROUND(C11*$I$9,-3)","v":233000},null,{"$f":"ROUND(((C11+C11*$I$9)*$I$13+C11+C11*$I$9),-3)","v":1636000},null,0.12,"CE Percentage"]
[]
[null,"Project TOTAL CN+CE",{"$f":"C9+C11","v":11747000},null,{"$f":"E9+E11","v":2171000},null,{"$f":"G9+G11","v":15263000},null,9.6600000000000005E-2,"IDC Percentage"]
[null,null,null,null,null,null,null,null,2022,"Fiscal Year"]
[{"$f":"CONCATENATE(LEFT(K15,29),FIXED(D25,0),MID(K15,36,22),I20*100,MID(K15,60,33),I23*100,MID(K15,95,19))","v":"The estimate above includes $700,000 for traffic control, 30% allowance for contingency, and 10% for mobilization."},null,null,null,null,null,null,null,null,null,"The estimate above includes $XX,XXX for traffic control, XX% allowance for contingency, and XX% for mobilization."]
[]
[{"$f":"CONCATENATE(LEFT(K17,211),I13*100,MID(K17,216,9),FIXED(I14,0,TRUE),MID(K17,229,1))","v":"Note:  Inflation is calculated in PPMS to the letting date. If there is no letting date, the project is assumed to be inside the current TCP and is given a maximum of 5 years until letting. IDC is calculated at 9.66% for FY 2022."},null,null,null,null,null,null,null,null,null,"Note:  Inflation is calculated in PPMS to the letting date. If there is no letting date, the project is assumed to be inside the current TCP and is given a maximum of 5 years until letting. IDC is calculated at X.XX% for FY XXXX. "]
[]
[null,"Subtotal w/out Contingency","=",8067667.2699999996]
[null,"Add Contingency","+",{"$f":"ROUND((D19)*I20,0)","v":2420300},null,null,null,null,0.3,"Contingency Percentage. NOTE: Calculated value should equal calculated cost on Full estimate."]
[null,null,"=",{"$f":"D19+D20","v":10487967.27},null,"= Total CN"]
[]
[null,"Mobilization","=",733424.3,null,null,null,null,{"$f":"ROUND(1/((D19/D23)-1),4)","v":0.1},"Calculated Mobilization Percentage. NOTE: Calculated value should equal the AASHTOWare Estimate \"% on top\"."]
[]
[null,"Traffic Control","=",700000]